0) { $arr=mysql_fetch_array ($res); if ((md5($MD5_PREFIX.$TPL_password) == $arr[password]) || $HTTP_COOKIE_VARS["$LOGGED_IN_COOKIE"]) { if(!$HTTP_COOKIE_VARS["$LOGGED_IN_NICK"]) { //-- Login user setcookie($LOGGED_IN_COOKIE,$arr["id"]); setcookie($LOGGED_IN_NICK,$TPL_nick); } $TPL_id_hidden=$arr[id]; $TPL_name=$arr[name]; $TPL_nick=$arr[nick]; $TPL_password=""; $TPL_repeat_password=""; $TPL_email=$arr[email]; $TPL_birthdate=$arr[birthdate ]; $TPL_address=$arr[address]; $TPL_city=$arr[city]; $TPL_prov=$arr[prov]; $TPL_country=$arr[country]; $TPL_zip=$arr[zip]; $TPL_phone=$arr[phone]; $TPL_status = $arr[status]; $TPL_p18 = $arr[p18]; $TPL_newsletter = $arr[newsletter]; if ($arr[rate_num]) { $TPL_rate=round($arr[rate_sum]/$arr[rate_num]); } else { $TPL_rate=0; } $TPL_birthdate = substr($TPL_birthdate,6,2).".". substr($TPL_birthdate,4,2).".". substr($TPL_birthdate,0,4); $country=""; while (list ($code, $name) = each ($countries)) { $bodi = $code + 1; $country .= " 0) { $TPL_err=1; $TPL_errmsg=$ERR_011; } else if ($TPL_password!=$TPL_repeat_password) { $TPL_err=1; $TPL_errmsg=$ERR_109; } else if (strlen($TPL_email)<5) //Primitive mail check { $TPL_err=1; $TPL_errmsg=$ERR_110; } else if (strlen($TPL_zip)<5) //Primitive zip check { $TPL_err=1; $TPL_errmsg=$ERR_616; } else if (strlen($TPL_phone)<3) //Primitive phone check { $TPL_err=1; $TPL_errmsg=$ERR_617; } else { $TPL_birthdate = substr($TPL_birthdate,6,4). substr($TPL_birthdate,3,2). substr($TPL_birthdate,0,2); $sql="UPDATE users SET name=\"".AddSlashes($TPL_name) ."\", nick=\"". AddSlashes($TPL_nick) ."\", email=\"". AddSlashes($TPL_email) ."\", birthdate=\"". AddSlashes($TPL_birthdate) ."\", address=\"". AddSlashes($TPL_address) ."\", city=\"". AddSlashes($TPL_city) ."\", prov=\"". AddSlashes($TPL_prov) ."\", country=\"". AddSlashes($TPL_country - 1) ."\", zip=\"". AddSlashes($TPL_zip) ."\", phone=\"". AddSlashes($TPL_phone) ."\", status=\"". AddSlashes($TPL_status) ."\", newsletter=\"". AddSlashes($TPL_newsletter); if(strlen($TPL_password) > 0) { $sql .= "\", password=\"". md5($MD5_PREFIX.AddSlashes($TPL_password)); } if($TPL_p18 == "1") { $sql .= "\", p18=\"beantragt"; } if(strlen($TPL_p18) == 0) { $sql .= "\", p18=\"nicht beantragt"; } $sql .= "\" WHERE id='".AddSlashes($TPL_id_hidden)."'"; $echosql = $sql; $res=mysql_query ($sql); include "header.php"; include "templates/template_updated.html"; } } else { $TPL_err=1; $TPL_errmsg=$ERR_112; } } echo $echosql; if ($REQUEST_METHOD=="POST" && $action == "update" && $TPL_err) { include "header.php"; //-- If an error occures re-built countries $country=""; while (list ($code, $name) = each ($countries)) { $bodi = $code + 1; $country .= "